Devin Lee
Devin Lee
Reactions
-
Re: Breakdown of Tasks by Assignee
Unfortunately not, rows can only be listed once in Reports. You would have to have it listed twice in the sheet you are referencing which can have some syncing issues with data or choose to have a Le…1 · -
Re: Converting an Authorization Matrix into an Approval Sequence
@Colin Herrera Have you tried using LARGE? It can be used to pull the numbers based off the ranking in a range. =IFERROR(INDEX(COLLECT(Person:Person, Department:Department, CONTAINS([Department1]@row…1 · -
Re: Nested IF OR limits?
Hey @LakeWaconia You're missing closed parenthesis for some of your WORKDAY and OR statements. One easy way to check these things is to just cycle though the end parenthesis and make sure they are re…1 · -
Re: Conditional formatting based off of blank date cell
Hey @bridgets You want to check to see if it's blank first otherwise the blank will trigger the Red. Try this formula =IF(ISBLANK([Target Date]@row), "Gray", IF([Target Date]@row < TODAY…1 · -
Re: I think this IF Then formula.....but need help
@Melissa Lee Try this: =IF([Global Level]@row = "GL4", 0.025, IF([Global Level]@row = "GL5", 0.05, IF([Global Level]@row = "GL6", 0.075, IF([Global Level]@row = "GL…1 ·
